





create table USER1
( id number constraints PK_USER1 PRIMARY KEY,
NAME NVARCHAR2(20) constraints UQ_USER1_NAME UNIQUE NOT NULL,
Pwd  NVARCHAR2(6) not null,
email NVARCHAR2(6),
BIRTHDATE DATE
);

create sequence SEQ_USER1;

INSERT into USER1(id,name,pwd,email,birthdate) values(seq_users.nextval,'jack_ma1','123','12345',sysdate);
INSERT into USER1(id,name,pwd,email,birthdate) values(seq_users.nextval,'jack_ma2','123','12345',sysdate);
INSERT into USER1(id,name,pwd,email,birthdate) values(seq_users.nextval,'jack_ma3','123','12345',sysdate);
INSERT into USER1(id,name,pwd,email,birthdate) values(seq_users.nextval,'jack_ma4','123','12345',sysdate);
INSERT into USER1(id,name,pwd,email,birthdate) values(seq_users.nextval,'jack_ma5','123','12345',sysdate);

update users set age=1 where id=2;
update user1 set pwd='333'   where id=27;

select * from USER1;




